package com.suxin.datahub.core.query;

/**
 * @Classname MySqlQueryImpl
 * @Description [ TODO ]
 * @Author Tang
 * @Date 2020/11/10 9:14
 * @Created by ASUS
 */
public class OracleQueryServiceImpl extends AbstractBaseQueryService {

    @Override
    public String getTables() {
        return "select table_name from user_tables;";
    }

    @Override
    public String getTableColumns(String tableSchema, String tableName) {
        return "SELECT TABLE_NAME as tableName,COLUMN_NAME as columnName,DATA_TYPE as dataType,NULLABLE as isNullable " +
                "FROM USER_TAB_COLS WHERE TABLE_NAME = " + tableName;
    }
}